Overview
Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 180463 |
| Missing cells | 294968 |
| Missing cells (%) | 6.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 34.4 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 4 |
| Text | 7 |
| Categorical | 6 |
| Unsupported | 2 |
facility_type has constant value "DSNY Garage" | Constant |
Request_Closing_Time_in_Hours is highly overall correlated with days_to_close | High correlation |
borough is highly overall correlated with city and 4 other fields | High correlation |
city is highly overall correlated with borough and 4 other fields | High correlation |
days_to_close is highly overall correlated with Request_Closing_Time_in_Hours | High correlation |
geo_status is highly overall correlated with latitude and 2 other fields | High correlation |
incident_zip is highly overall correlated with borough and 3 other fields | High correlation |
latitude is highly overall correlated with borough and 3 other fields | High correlation |
longitude is highly overall correlated with borough and 3 other fields | High correlation |
zip_codes is highly overall correlated with borough and 4 other fields | High correlation |
status is highly imbalanced (90.4%) | Imbalance |
geo_status is highly imbalanced (78.6%) | Imbalance |
resolution_date_update has 1908 (1.1%) missing values | Missing |
resolution_description has 5306 (2.9%) missing values | Missing |
descriptor has 4634 (2.6%) missing values | Missing |
location_type has 51464 (28.5%) missing values | Missing |
incident_zip has 4964 (2.8%) missing values | Missing |
incident_address has 10619 (5.9%) missing values | Missing |
city has 13839 (7.7%) missing values | Missing |
facility_type has 174232 (96.5%) missing values | Missing |
latitude has 6143 (3.4%) missing values | Missing |
longitude has 6143 (3.4%) missing values | Missing |
location has 6143 (3.4%) missing values | Missing |
zip_codes has 8411 (4.7%) missing values | Missing |
unique_key has unique values | Unique |
Request_Closing_Time is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Request_Closing_Time_in_Seconds is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
days_to_close has 8058 (4.5%) zeros | Zeros |
Reproduction
| Analysis started | 2026-01-11 14:12:58.966211 |
|---|---|
| Analysis finished | 2026-01-11 14:13:29.292310 |
| Duration | 30.33 seconds |
| Software version | ydata-profiling vv4.18.0 |
| Download configuration | config.json |
Variables
unique_key
Real number (ℝ)
Unique
| Distinct | 180463 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44593541 |
| Minimum | 43859987 |
|---|---|
| Maximum | 45054995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 43859987 |
|---|---|
| 5-th percentile | 43944366 |
| Q1 | 44159886 |
| median | 44884510 |
| Q3 | 44953045 |
| 95-th percentile | 45033377 |
| Maximum | 45054995 |
| Range | 1195008 |
| Interquartile range (IQR) | 793159.5 |
Descriptive statistics
| Standard deviation | 420523.01 |
|---|---|
| Coefficient of variation (CV) | 0.0094301327 |
| Kurtosis | -1.5586873 |
| Mean | 44593541 |
| Median Absolute Deviation (MAD) | 150981 |
| Skewness | -0.42679626 |
| Sum | 8.0474842 × 1012 |
| Variance | 1.768396 × 1011 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 45054995 | 1 | < 0.1% |
| 43859987 | 1 | < 0.1% |
| 43859988 | 1 | < 0.1% |
| 43859989 | 1 | < 0.1% |
| 43859990 | 1 | < 0.1% |
| 43859991 | 1 | < 0.1% |
| 43860006 | 1 | < 0.1% |
| 43860007 | 1 | < 0.1% |
| 43860023 | 1 | < 0.1% |
| 43860038 | 1 | < 0.1% |
| Other values (180453) | 180453 |
| Value | Count | Frequency (%) |
| 43859987 | 1 | |
| 43859988 | 1 | |
| 43859989 | 1 | |
| 43859990 | 1 | |
| 43859991 | 1 | |
| 43860006 | 1 | |
| 43860007 | 1 | |
| 43860023 | 1 | |
| 43860038 | 1 | |
| 43860039 | 1 |
| Value | Count | Frequency (%) |
| 45054995 | 1 | |
| 45054994 | 1 | |
| 45054993 | 1 | |
| 45054992 | 1 | |
| 45054991 | 1 | |
| 45054981 | 1 | |
| 45054980 | 1 | |
| 45054958 | 1 | |
| 45054956 | 1 | |
| 45054955 | 1 |
created_at
Date
| Distinct | 161176 |
|---|---|
| Distinct (%) | 89.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2019-09-22 11:38:28 |
|---|---|
| Maximum | 2019-12-01 01:48:45 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
closed_at
Date
| Distinct | 125852 |
|---|---|
| Distinct (%) | 69.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2019-09-20 11:08:00 |
|---|---|
| Maximum | 2019-12-01 01:59:50 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Missing
| Distinct | 119935 |
|---|---|
| Distinct (%) | 67.2% |
| Missing | 1908 |
| Missing (%) | 1.1% |
| Memory size | 2.8 MiB |
| Minimum | 2019-09-20 11:08:00 |
|---|---|
| Maximum | 2019-12-01 06:59:42 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Missing
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 5306 |
| Missing (%) | 2.9% |
| Memory size | 2.8 MiB |
Length
| Max length | 345 |
|---|---|
| Median length | 325 |
| Mean length | 146.93671 |
| Min length | 26 |
Unique
| Unique | 55 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | After performing a thorough search, the Department of Transportation was unable to find the lost ite |
|---|---|
| 2nd row | The Police Department responded and upon arrival those responsible for the condition were gone. |
| 3rd row | The agency was unable to respond to this complaint because they allocated resources to other critica |
| 4th row | The Department of Sanitation removed the items. |
| 5th row | The Department of Sanitation removed the items. |
| Value | Count | Frequency (%) |
| the | 456010 | 12.1% |
| complaint | 169156 | 4.5% |
| and | 155226 | 4.1% |
| department | 152202 | 4.0% |
| to | 144117 | 3.8% |
| of | 140993 | 3.7% |
| a | 101372 | 2.7% |
| police | 93698 | 2.5% |
| condition | 88041 | 2.3% |
| responded | 80463 | 2.1% |
| Other values (722) | 2190985 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3602558 | ||
| e | 2426994 | 9.4% |
| t | 2046052 | 7.9% |
| o | 1948060 | 7.6% |
| n | 1790879 | 7.0% |
| i | 1690257 | 6.6% |
| a | 1523465 | 5.9% |
| r | 984641 | 3.8% |
| d | 927720 | 3.6% |
| l | 884659 | 3.4% |
| Other values (64) | 7911708 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 25736993 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3602558 | ||
| e | 2426994 | 9.4% |
| t | 2046052 | 7.9% |
| o | 1948060 | 7.6% |
| n | 1790879 | 7.0% |
| i | 1690257 | 6.6% |
| a | 1523465 | 5.9% |
| r | 984641 | 3.8% |
| d | 927720 | 3.6% |
| l | 884659 | 3.4% |
| Other values (64) | 7911708 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 25736993 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3602558 | ||
| e | 2426994 | 9.4% |
| t | 2046052 | 7.9% |
| o | 1948060 | 7.6% |
| n | 1790879 | 7.0% |
| i | 1690257 | 6.6% |
| a | 1523465 | 5.9% |
| r | 984641 | 3.8% |
| d | 927720 | 3.6% |
| l | 884659 | 3.4% |
| Other values (64) | 7911708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 25736993 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3602558 | ||
| e | 2426994 | 9.4% |
| t | 2046052 | 7.9% |
| o | 1948060 | 7.6% |
| n | 1790879 | 7.0% |
| i | 1690257 | 6.6% |
| a | 1523465 | 5.9% |
| r | 984641 | 3.8% |
| d | 927720 | 3.6% |
| l | 884659 | 3.4% |
| Other values (64) | 7911708 |
days_to_close
Real number (ℝ)
High correlation Zeros
| Distinct | 110535 |
|---|---|
| Distinct (%) | 61.6% |
| Missing | 1162 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1059367 |
| Minimum | 0 |
|---|---|
| Maximum | 67.435093 |
| Zeros | 8058 |
| Zeros (%) | 4.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0011342592 |
| Q1 | 0.084027778 |
| median | 0.34159722 |
| Q3 | 1.9451389 |
| 95-th percentile | 10.143484 |
| Maximum | 67.435093 |
| Range | 67.435093 |
| Interquartile range (IQR) | 1.8611111 |
Descriptive statistics
| Standard deviation | 5.0419995 |
|---|---|
| Coefficient of variation (CV) | 2.3941838 |
| Kurtosis | 38.441994 |
| Mean | 2.1059367 |
| Median Absolute Deviation (MAD) | 0.32822917 |
| Skewness | 5.3403008 |
| Sum | 377596.55 |
| Variance | 25.421759 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8058 | 4.5% |
| 1.15740113 × 10-5 | 127 | 0.1% |
| 0.001388888806 | 106 | 0.1% |
| 2.314802259 × 10-5 | 105 | 0.1% |
| 0.0006944444031 | 104 | 0.1% |
| 0.02083333349 | 70 | < 0.1% |
| 0.002083333209 | 64 | < 0.1% |
| 0.007638888899 | 63 | < 0.1% |
| 0.05347222229 | 63 | < 0.1% |
| 0.03125 | 60 | < 0.1% |
| Other values (110525) | 170481 | |
| (Missing) | 1162 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 8058 | |
| 1.15740113 × 10-5 | 127 | 0.1% |
| 1.157447696 × 10-5 | 32 | < 0.1% |
| 2.314802259 × 10-5 | 105 | 0.1% |
| 2.314848825 × 10-5 | 41 | < 0.1% |
| 3.472203389 × 10-5 | 53 | < 0.1% |
| 3.472249955 × 10-5 | 25 | < 0.1% |
| 4.629604518 × 10-5 | 11 | < 0.1% |
| 4.629651085 × 10-5 | 22 | < 0.1% |
| 5.787005648 × 10-5 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 67.43509259 | 1 | |
| 67.3041088 | 1 | |
| 67.04428241 | 1 | |
| 66.14087963 | 1 | |
| 66.0337963 | 1 | |
| 65.95501157 | 1 | |
| 65.93793981 | 1 | |
| 65.91928241 | 1 | |
| 65.86940972 | 1 | |
| 65.67532407 | 1 |
agency
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| NYPD | |
|---|---|
| HPD | |
| DOT | |
| DEP | |
| DSNY | |
| Other values (9) |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.5355558 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DOT |
|---|---|
| 2nd row | NYPD |
| 3rd row | DOHMH |
| 4th row | EDC |
| 5th row | DPR |
Common Values
| Value | Count | Frequency (%) |
| NYPD | 82846 | |
| HPD | 39310 | |
| DOT | 17548 | 9.7% |
| DEP | 12559 | 7.0% |
| DSNY | 9568 | 5.3% |
| DOB | 8989 | 5.0% |
| DHS | 2665 | 1.5% |
| DPR | 2160 | 1.2% |
| DOHMH | 2107 | 1.2% |
| TLC | 1554 | 0.9% |
| Other values (4) | 1157 | 0.6% |
Length
| Value | Count | Frequency (%) |
| nypd | 82846 | |
| hpd | 39310 | |
| dot | 17548 | 9.7% |
| dep | 12559 | 7.0% |
| dsny | 9568 | 5.3% |
| dob | 8989 | 5.0% |
| dhs | 2665 | 1.5% |
| dpr | 2160 | 1.2% |
| dohmh | 2107 | 1.2% |
| tlc | 1554 | 0.9% |
| Other values (4) | 1157 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 178909 | |
| P | 136875 | |
| Y | 92414 | |
| N | 92414 | |
| H | 46189 | 7.2% |
| O | 28741 | 4.5% |
| T | 19122 | 3.0% |
| E | 13108 | 2.1% |
| S | 12233 | 1.9% |
| B | 8989 | 1.4% |
| Other values (6) | 9043 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 638037 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 178909 | |
| P | 136875 | |
| Y | 92414 | |
| N | 92414 | |
| H | 46189 | 7.2% |
| O | 28741 | 4.5% |
| T | 19122 | 3.0% |
| E | 13108 | 2.1% |
| S | 12233 | 1.9% |
| B | 8989 | 1.4% |
| Other values (6) | 9043 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 638037 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 178909 | |
| P | 136875 | |
| Y | 92414 | |
| N | 92414 | |
| H | 46189 | 7.2% |
| O | 28741 | 4.5% |
| T | 19122 | 3.0% |
| E | 13108 | 2.1% |
| S | 12233 | 1.9% |
| B | 8989 | 1.4% |
| Other values (6) | 9043 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 638037 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 178909 | |
| P | 136875 | |
| Y | 92414 | |
| N | 92414 | |
| H | 46189 | 7.2% |
| O | 28741 | 4.5% |
| T | 19122 | 3.0% |
| E | 13108 | 2.1% |
| S | 12233 | 1.9% |
| B | 8989 | 1.4% |
| Other values (6) | 9043 | 1.4% |
agency_name
Text
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 59 |
|---|---|
| Median length | 54 |
| Mean length | 34.319556 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Department of Transportation |
|---|---|
| 2nd row | New York City Police Department |
| 3rd row | Department of Health and Mental Hygiene |
| 4th row | Economic Development Corporation |
| 5th row | Department of Parks and Recreation |
| Value | Count | Frequency (%) |
| department | 168884 | |
| of | 86038 | |
| new | 82846 | |
| york | 82846 | |
| police | 82846 | |
| city | 82846 | |
| and | 45426 | 5.3% |
| development | 39772 | 4.6% |
| preservation | 39310 | 4.6% |
| housing | 39310 | 4.6% |
| Other values (58) | 109518 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 760603 | |
| 679179 | 11.0% | |
| t | 589649 | 9.5% |
| o | 467373 | 7.5% |
| n | 451053 | 7.3% |
| r | 405969 | 6.6% |
| i | 321937 | 5.2% |
| a | 319918 | 5.2% |
| m | 229654 | 3.7% |
| p | 226666 | 3.7% |
| Other values (42) | 1741409 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6193410 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 760603 | |
| 679179 | 11.0% | |
| t | 589649 | 9.5% |
| o | 467373 | 7.5% |
| n | 451053 | 7.3% |
| r | 405969 | 6.6% |
| i | 321937 | 5.2% |
| a | 319918 | 5.2% |
| m | 229654 | 3.7% |
| p | 226666 | 3.7% |
| Other values (42) | 1741409 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6193410 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 760603 | |
| 679179 | 11.0% | |
| t | 589649 | 9.5% |
| o | 467373 | 7.5% |
| n | 451053 | 7.3% |
| r | 405969 | 6.6% |
| i | 321937 | 5.2% |
| a | 319918 | 5.2% |
| m | 229654 | 3.7% |
| p | 226666 | 3.7% |
| Other values (42) | 1741409 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6193410 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 760603 | |
| 679179 | 11.0% | |
| t | 589649 | 9.5% |
| o | 467373 | 7.5% |
| n | 451053 | 7.3% |
| r | 405969 | 6.6% |
| i | 321937 | 5.2% |
| a | 319918 | 5.2% |
| m | 229654 | 3.7% |
| p | 226666 | 3.7% |
| Other values (42) | 1741409 |
complaint_type
Text
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 33 |
| Mean length | 16.640652 |
| Min length | 4 |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Ferry Inquiry |
|---|---|
| 2nd row | Drinking |
| 3rd row | Rodent |
| 4th row | Noise - Helicopter |
| 5th row | Violation of Park Rules |
| Value | Count | Frequency (%) |
| noise | 43657 | 10.7% |
| 39805 | 9.8% | |
| water | 37081 | 9.1% |
| heat/hot | 31824 | 7.8% |
| residential | 23746 | 5.8% |
| parking | 22067 | 5.4% |
| illegal | 20462 | 5.0% |
| condition | 17022 | 4.2% |
| blocked | 14904 | 3.7% |
| driveway | 14904 | 3.7% |
| Other values (171) | 141717 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 297726 | 9.9% |
| i | 244223 | 8.1% |
| 226726 | 7.5% | |
| l | 173510 | 5.8% |
| a | 141938 | 4.7% |
| n | 140541 | 4.7% |
| o | 140502 | 4.7% |
| t | 130525 | 4.3% |
| s | 120167 | 4.0% |
| T | 109628 | 3.7% |
| Other values (44) | 1277536 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3003022 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 297726 | 9.9% |
| i | 244223 | 8.1% |
| 226726 | 7.5% | |
| l | 173510 | 5.8% |
| a | 141938 | 4.7% |
| n | 140541 | 4.7% |
| o | 140502 | 4.7% |
| t | 130525 | 4.3% |
| s | 120167 | 4.0% |
| T | 109628 | 3.7% |
| Other values (44) | 1277536 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3003022 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 297726 | 9.9% |
| i | 244223 | 8.1% |
| 226726 | 7.5% | |
| l | 173510 | 5.8% |
| a | 141938 | 4.7% |
| n | 140541 | 4.7% |
| o | 140502 | 4.7% |
| t | 130525 | 4.3% |
| s | 120167 | 4.0% |
| T | 109628 | 3.7% |
| Other values (44) | 1277536 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3003022 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 297726 | 9.9% |
| i | 244223 | 8.1% |
| 226726 | 7.5% | |
| l | 173510 | 5.8% |
| a | 141938 | 4.7% |
| n | 140541 | 4.7% |
| o | 140502 | 4.7% |
| t | 130525 | 4.3% |
| s | 120167 | 4.0% |
| T | 109628 | 3.7% |
| Other values (44) | 1277536 |
descriptor
Text
Missing
| Distinct | 622 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4634 |
| Missing (%) | 2.6% |
| Memory size | 2.8 MiB |
Length
| Max length | 80 |
|---|---|
| Median length | 71 |
| Mean length | 18.219395 |
| Min length | 3 |
Unique
| Unique | 79 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Lost and Found |
|---|---|
| 2nd row | In Public |
| 3rd row | Rat Sighting |
| 4th row | Other |
| 5th row | Smoking |
| Value | Count | Frequency (%) |
| loud | 26967 | 6.1% |
| building | 23538 | 5.3% |
| music/party | 22505 | 5.1% |
| entire | 21170 | 4.8% |
| access | 14904 | 3.4% |
| no | 12568 | 2.8% |
| only | 10808 | 2.4% |
| apartment | 10804 | 2.4% |
| blocked | 10559 | 2.4% |
| 8274 | 1.9% | |
| Other values (944) | 280049 |
Most occurring characters
| Value | Count | Frequency (%) |
| 266434 | 8.3% | |
| e | 204755 | 6.4% |
| i | 189936 | 5.9% |
| o | 159751 | 5.0% |
| t | 146373 | 4.6% |
| n | 143890 | 4.5% |
| r | 132943 | 4.1% |
| a | 130962 | 4.1% |
| s | 116060 | 3.6% |
| c | 112489 | 3.5% |
| Other values (63) | 1599905 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3203498 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 266434 | 8.3% | |
| e | 204755 | 6.4% |
| i | 189936 | 5.9% |
| o | 159751 | 5.0% |
| t | 146373 | 4.6% |
| n | 143890 | 4.5% |
| r | 132943 | 4.1% |
| a | 130962 | 4.1% |
| s | 116060 | 3.6% |
| c | 112489 | 3.5% |
| Other values (63) | 1599905 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3203498 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 266434 | 8.3% | |
| e | 204755 | 6.4% |
| i | 189936 | 5.9% |
| o | 159751 | 5.0% |
| t | 146373 | 4.6% |
| n | 143890 | 4.5% |
| r | 132943 | 4.1% |
| a | 130962 | 4.1% |
| s | 116060 | 3.6% |
| c | 112489 | 3.5% |
| Other values (63) | 1599905 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3203498 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 266434 | 8.3% | |
| e | 204755 | 6.4% |
| i | 189936 | 5.9% |
| o | 159751 | 5.0% |
| t | 146373 | 4.6% |
| n | 143890 | 4.5% |
| r | 132943 | 4.1% |
| a | 130962 | 4.1% |
| s | 116060 | 3.6% |
| c | 112489 | 3.5% |
| Other values (63) | 1599905 |
location_type
Text
Missing
| Distinct | 83 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 51464 |
| Missing (%) | 28.5% |
| Memory size | 2.8 MiB |
Length
| Max length | 29 |
|---|---|
| Median length | 28 |
| Mean length | 17.319297 |
| Min length | 3 |
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bridge |
|---|---|
| 2nd row | Street/Sidewalk |
| 3rd row | Street Area |
| 4th row | Above Address |
| 5th row | Park |
| Value | Count | Frequency (%) |
| residential | 60052 | |
| street/sidewalk | 43152 | |
| building | 40611 | |
| building/house | 20630 | 10.6% |
| street | 7854 | 4.0% |
| sidewalk | 7054 | 3.6% |
| store/commercial | 3006 | 1.5% |
| family | 1494 | 0.8% |
| club/bar/restaurant | 1367 | 0.7% |
| 3 | 833 | 0.4% |
| Other values (93) | 9091 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 228529 | 10.2% |
| I | 157240 | 7.0% |
| S | 144541 | 6.5% |
| i | 143318 | 6.4% |
| t | 131964 | 5.9% |
| l | 101264 | 4.5% |
| d | 95052 | 4.3% |
| a | 83175 | 3.7% |
| L | 79750 | 3.6% |
| D | 79279 | 3.5% |
| Other values (43) | 990060 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2234172 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 228529 | 10.2% |
| I | 157240 | 7.0% |
| S | 144541 | 6.5% |
| i | 143318 | 6.4% |
| t | 131964 | 5.9% |
| l | 101264 | 4.5% |
| d | 95052 | 4.3% |
| a | 83175 | 3.7% |
| L | 79750 | 3.6% |
| D | 79279 | 3.5% |
| Other values (43) | 990060 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2234172 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 228529 | 10.2% |
| I | 157240 | 7.0% |
| S | 144541 | 6.5% |
| i | 143318 | 6.4% |
| t | 131964 | 5.9% |
| l | 101264 | 4.5% |
| d | 95052 | 4.3% |
| a | 83175 | 3.7% |
| L | 79750 | 3.6% |
| D | 79279 | 3.5% |
| Other values (43) | 990060 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2234172 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 228529 | 10.2% |
| I | 157240 | 7.0% |
| S | 144541 | 6.5% |
| i | 143318 | 6.4% |
| t | 131964 | 5.9% |
| l | 101264 | 4.5% |
| d | 95052 | 4.3% |
| a | 83175 | 3.7% |
| L | 79750 | 3.6% |
| D | 79279 | 3.5% |
| Other values (43) | 990060 |
incident_zip
Real number (ℝ)
High correlation Missing
| Distinct | 220 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4964 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10809.206 |
| Minimum | 10000 |
|---|---|
| Maximum | 12345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10011 |
| Q1 | 10309 |
| median | 11203 |
| Q3 | 11235 |
| 95-th percentile | 11422 |
| Maximum | 12345 |
| Range | 2345 |
| Interquartile range (IQR) | 926 |
Descriptive statistics
| Standard deviation | 549.61896 |
|---|---|
| Coefficient of variation (CV) | 0.050847301 |
| Kurtosis | -1.5813326 |
| Mean | 10809.206 |
| Median Absolute Deviation (MAD) | 220 |
| Skewness | -0.305071 |
| Sum | 1.8970049 × 109 |
| Variance | 302080.97 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11226 | 3246 | 1.8% |
| 11385 | 2874 | 1.6% |
| 10467 | 2725 | 1.5% |
| 10457 | 2119 | 1.2% |
| 10468 | 2097 | 1.2% |
| 10453 | 2096 | 1.2% |
| 10452 | 2049 | 1.1% |
| 11221 | 1975 | 1.1% |
| 11207 | 1963 | 1.1% |
| 10458 | 1951 | 1.1% |
| Other values (210) | 152404 | |
| (Missing) | 4964 | 2.8% |
| Value | Count | Frequency (%) |
| 10000 | 14 | < 0.1% |
| 10001 | 923 | |
| 10002 | 1635 | |
| 10003 | 1496 | |
| 10004 | 380 | 0.2% |
| 10005 | 307 | 0.2% |
| 10006 | 127 | 0.1% |
| 10007 | 450 | 0.2% |
| 10009 | 1371 | |
| 10010 | 659 |
| Value | Count | Frequency (%) |
| 12345 | 1 | < 0.1% |
| 11697 | 11 | < 0.1% |
| 11694 | 454 | |
| 11693 | 201 | 0.1% |
| 11692 | 382 | 0.2% |
| 11691 | 997 | |
| 11436 | 511 | |
| 11435 | 1045 | |
| 11434 | 994 | |
| 11433 | 787 |
incident_address
Text
Missing
| Distinct | 81684 |
|---|---|
| Distinct (%) | 48.1% |
| Missing | 10619 |
| Missing (%) | 5.9% |
| Memory size | 2.8 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 35 |
| Mean length | 17.738613 |
| Min length | 3 |
Unique
| Unique | 55165 ? |
|---|---|
| Unique (%) | 32.5% |
Sample
| 1st row | SAINT GEORGE FERRY |
|---|---|
| 2nd row | 600 RIDGEWOOD AVENUE |
| 3rd row | 11 GREENE STREET |
| 4th row | 101-21 75 ROAD |
| 5th row | 60-09 SAINT FELIX AVENUE |
| Value | Count | Frequency (%) |
| street | 75214 | 13.9% |
| avenue | 64660 | 12.0% |
| east | 18061 | 3.3% |
| west | 13940 | 2.6% |
| boulevard | 6054 | 1.1% |
| place | 5536 | 1.0% |
| road | 5513 | 1.0% |
| broadway | 2369 | 0.4% |
| parkway | 2258 | 0.4% |
| park | 1986 | 0.4% |
| Other values (18402) | 344867 |
Most occurring characters
| Value | Count | Frequency (%) |
| 422670 | ||
| E | 400231 | 13.3% |
| T | 227882 | 7.6% |
| A | 171349 | 5.7% |
| R | 157267 | 5.2% |
| S | 150751 | 5.0% |
| 1 | 142421 | 4.7% |
| N | 129924 | 4.3% |
| 2 | 90632 | 3.0% |
| U | 89709 | 3.0% |
| Other values (41) | 1029961 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3012797 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 422670 | ||
| E | 400231 | 13.3% |
| T | 227882 | 7.6% |
| A | 171349 | 5.7% |
| R | 157267 | 5.2% |
| S | 150751 | 5.0% |
| 1 | 142421 | 4.7% |
| N | 129924 | 4.3% |
| 2 | 90632 | 3.0% |
| U | 89709 | 3.0% |
| Other values (41) | 1029961 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3012797 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 422670 | ||
| E | 400231 | 13.3% |
| T | 227882 | 7.6% |
| A | 171349 | 5.7% |
| R | 157267 | 5.2% |
| S | 150751 | 5.0% |
| 1 | 142421 | 4.7% |
| N | 129924 | 4.3% |
| 2 | 90632 | 3.0% |
| U | 89709 | 3.0% |
| Other values (41) | 1029961 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3012797 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 422670 | ||
| E | 400231 | 13.3% |
| T | 227882 | 7.6% |
| A | 171349 | 5.7% |
| R | 157267 | 5.2% |
| S | 150751 | 5.0% |
| 1 | 142421 | 4.7% |
| N | 129924 | 4.3% |
| 2 | 90632 | 3.0% |
| U | 89709 | 3.0% |
| Other values (41) | 1029961 |
city
Categorical
High correlation Missing
| Distinct | 48 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 13839 |
| Missing (%) | 7.7% |
| Memory size | 2.8 MiB |
| BROOKLYN | |
|---|---|
| NEW YORK | |
| BRONX | |
| STATEN ISLAND | |
| JAMAICA | 4374 |
| Other values (43) |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 8.1980567 |
| Min length | 5 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | STATEN ISLAND |
|---|---|
| 2nd row | BROOKLYN |
| 3rd row | NEW YORK |
| 4th row | FOREST HILLS |
| 5th row | RIDGEWOOD |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 50866 | |
| NEW YORK | 36334 | |
| BRONX | 31511 | |
| STATEN ISLAND | 7270 | 4.0% |
| JAMAICA | 4374 | 2.4% |
| ASTORIA | 3126 | 1.7% |
| FLUSHING | 2886 | 1.6% |
| RIDGEWOOD | 2731 | 1.5% |
| FRESH MEADOWS | 1762 | 1.0% |
| CORONA | 1618 | 0.9% |
| Other values (38) | 24146 | |
| (Missing) | 13839 | 7.7% |
Length
| Value | Count | Frequency (%) |
| brooklyn | 50866 | |
| new | 36368 | |
| york | 36334 | |
| bronx | 31511 | |
| island | 8527 | 3.7% |
| staten | 7270 | 3.1% |
| jamaica | 4374 | 1.9% |
| park | 3444 | 1.5% |
| astoria | 3126 | 1.3% |
| flushing | 2886 | 1.2% |
| Other values (52) | 46990 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 205761 | |
| N | 153584 | |
| R | 144560 | |
| K | 94483 | 6.9% |
| Y | 91244 | 6.7% |
| B | 84379 | 6.2% |
| L | 81437 | 6.0% |
| E | 75614 | 5.5% |
| 65072 | 4.8% | |
| A | 58545 | 4.3% |
| Other values (17) | 311314 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1365993 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 205761 | |
| N | 153584 | |
| R | 144560 | |
| K | 94483 | 6.9% |
| Y | 91244 | 6.7% |
| B | 84379 | 6.2% |
| L | 81437 | 6.0% |
| E | 75614 | 5.5% |
| 65072 | 4.8% | |
| A | 58545 | 4.3% |
| Other values (17) | 311314 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1365993 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 205761 | |
| N | 153584 | |
| R | 144560 | |
| K | 94483 | 6.9% |
| Y | 91244 | 6.7% |
| B | 84379 | 6.2% |
| L | 81437 | 6.0% |
| E | 75614 | 5.5% |
| 65072 | 4.8% | |
| A | 58545 | 4.3% |
| Other values (17) | 311314 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1365993 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 205761 | |
| N | 153584 | |
| R | 144560 | |
| K | 94483 | 6.9% |
| Y | 91244 | 6.7% |
| B | 84379 | 6.2% |
| L | 81437 | 6.0% |
| E | 75614 | 5.5% |
| 65072 | 4.8% | |
| A | 58545 | 4.3% |
| Other values (17) | 311314 |
facility_type
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 174232 |
| Missing (%) | 96.5% |
| Memory size | 2.8 MiB |
| DSNY Garage |
|---|
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DSNY Garage |
|---|---|
| 2nd row | DSNY Garage |
| 3rd row | DSNY Garage |
| 4th row | DSNY Garage |
| 5th row | DSNY Garage |
Common Values
| Value | Count | Frequency (%) |
| DSNY Garage | 6231 | 3.5% |
| (Missing) | 174232 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dsny | 6231 | |
| garage | 6231 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12462 | |
| D | 6231 | |
| S | 6231 | |
| N | 6231 | |
| 6231 | ||
| Y | 6231 | |
| G | 6231 | |
| r | 6231 | |
| g | 6231 | |
| e | 6231 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68541 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 12462 | |
| D | 6231 | |
| S | 6231 | |
| N | 6231 | |
| 6231 | ||
| Y | 6231 | |
| G | 6231 | |
| r | 6231 | |
| g | 6231 | |
| e | 6231 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68541 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 12462 | |
| D | 6231 | |
| S | 6231 | |
| N | 6231 | |
| 6231 | ||
| Y | 6231 | |
| G | 6231 | |
| r | 6231 | |
| g | 6231 | |
| e | 6231 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68541 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 12462 | |
| D | 6231 | |
| S | 6231 | |
| N | 6231 | |
| 6231 | ||
| Y | 6231 | |
| G | 6231 | |
| r | 6231 | |
| g | 6231 | |
| e | 6231 |
status
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Closed | |
|---|---|
| Open | 2926 |
| Pending | 1211 |
| Assigned | 851 |
| In Progress | 16 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 5.9841574 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Closed |
|---|---|
| 2nd row | Closed |
| 3rd row | Closed |
| 4th row | Closed |
| 5th row | Closed |
Common Values
| Value | Count | Frequency (%) |
| Closed | 175459 | |
| Open | 2926 | 1.6% |
| Pending | 1211 | 0.7% |
| Assigned | 851 | 0.5% |
| In Progress | 16 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 175459 | |
| open | 2926 | 1.6% |
| pending | 1211 | 0.7% |
| assigned | 851 | 0.5% |
| in | 16 | < 0.1% |
| progress | 16 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 180463 | |
| d | 177521 | |
| s | 177193 | |
| o | 175475 | |
| C | 175459 | |
| l | 175459 | |
| n | 6215 | 0.6% |
| O | 2926 | 0.3% |
| p | 2926 | 0.3% |
| g | 2078 | 0.2% |
| Other values (6) | 4204 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1079919 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 180463 | |
| d | 177521 | |
| s | 177193 | |
| o | 175475 | |
| C | 175459 | |
| l | 175459 | |
| n | 6215 | 0.6% |
| O | 2926 | 0.3% |
| p | 2926 | 0.3% |
| g | 2078 | 0.2% |
| Other values (6) | 4204 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1079919 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 180463 | |
| d | 177521 | |
| s | 177193 | |
| o | 175475 | |
| C | 175459 | |
| l | 175459 | |
| n | 6215 | 0.6% |
| O | 2926 | 0.3% |
| p | 2926 | 0.3% |
| g | 2078 | 0.2% |
| Other values (6) | 4204 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1079919 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 180463 | |
| d | 177521 | |
| s | 177193 | |
| o | 175475 | |
| C | 175459 | |
| l | 175459 | |
| n | 6215 | 0.6% |
| O | 2926 | 0.3% |
| p | 2926 | 0.3% |
| g | 2078 | 0.2% |
| Other values (6) | 4204 | 0.4% |
borough
Categorical
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| BROOKLYN | |
|---|---|
| QUEENS | |
| MANHATTAN | |
| BRONX | |
| STATEN ISLAND |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.4066928 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STATEN ISLAND |
|---|---|
| 2nd row | BROOKLYN |
| 3rd row | MANHATTAN |
| 4th row | QUEENS |
| 5th row | QUEENS |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 53926 | |
| QUEENS | 43817 | |
| MANHATTAN | 40887 | |
| BRONX | 33524 | |
| STATEN ISLAND | 7661 | 4.2% |
| Unspecified | 648 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 53926 | |
| queens | 43817 | |
| manhattan | 40887 | |
| bronx | 33524 | |
| staten | 7661 | 4.1% |
| island | 7661 | 4.1% |
| unspecified | 648 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 228363 | |
| O | 141376 | |
| A | 137983 | |
| T | 97096 | 7.3% |
| E | 95295 | 7.1% |
| R | 87450 | 6.5% |
| B | 87450 | 6.5% |
| L | 61587 | 4.6% |
| S | 59139 | 4.4% |
| Y | 53926 | 4.0% |
| Other values (17) | 286969 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1336634 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 228363 | |
| O | 141376 | |
| A | 137983 | |
| T | 97096 | 7.3% |
| E | 95295 | 7.1% |
| R | 87450 | 6.5% |
| B | 87450 | 6.5% |
| L | 61587 | 4.6% |
| S | 59139 | 4.4% |
| Y | 53926 | 4.0% |
| Other values (17) | 286969 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1336634 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 228363 | |
| O | 141376 | |
| A | 137983 | |
| T | 97096 | 7.3% |
| E | 95295 | 7.1% |
| R | 87450 | 6.5% |
| B | 87450 | 6.5% |
| L | 61587 | 4.6% |
| S | 59139 | 4.4% |
| Y | 53926 | 4.0% |
| Other values (17) | 286969 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1336634 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 228363 | |
| O | 141376 | |
| A | 137983 | |
| T | 97096 | 7.3% |
| E | 95295 | 7.1% |
| R | 87450 | 6.5% |
| B | 87450 | 6.5% |
| L | 61587 | 4.6% |
| S | 59139 | 4.4% |
| Y | 53926 | 4.0% |
| Other values (17) | 286969 |
latitude
Real number (ℝ)
High correlation Missing
| Distinct | 52733 |
|---|---|
| Distinct (%) | 30.3% |
| Missing | 6143 |
| Missing (%) | 3.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.732341 |
| Minimum | 40.49968 |
|---|---|
| Maximum | 40.912868 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 40.49968 |
|---|---|
| 5-th percentile | 40.599769 |
| Q1 | 40.671188 |
| median | 40.725382 |
| Q3 | 40.807085 |
| 95-th percentile | 40.86837 |
| Maximum | 40.912868 |
| Range | 0.41318893 |
| Interquartile range (IQR) | 0.13589668 |
Descriptive statistics
| Standard deviation | 0.084627748 |
|---|---|
| Coefficient of variation (CV) | 0.0020776549 |
| Kurtosis | -0.84565002 |
| Mean | 40.732341 |
| Median Absolute Deviation (MAD) | 0.063064575 |
| Skewness | 0.041365333 |
| Sum | 7100461.6 |
| Variance | 0.0071618557 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.72195816 | 509 | 0.3% |
| 40.74742126 | 429 | 0.2% |
| 40.70380783 | 257 | 0.1% |
| 40.67934036 | 181 | 0.1% |
| 40.73009872 | 178 | 0.1% |
| 40.74499893 | 175 | 0.1% |
| 40.64831924 | 173 | 0.1% |
| 40.85443878 | 150 | 0.1% |
| 40.79013824 | 129 | 0.1% |
| 40.77863312 | 126 | 0.1% |
| Other values (52723) | 172013 | |
| (Missing) | 6143 | 3.4% |
| Value | Count | Frequency (%) |
| 40.49967957 | 1 | |
| 40.49972153 | 1 | |
| 40.49975204 | 1 | |
| 40.49975967 | 1 | |
| 40.49983597 | 1 | |
| 40.4998436 | 1 | |
| 40.49990463 | 1 | |
| 40.49999619 | 1 | |
| 40.50003815 | 1 | |
| 40.50011063 | 1 |
| Value | Count | Frequency (%) |
| 40.9128685 | 1 | < 0.1% |
| 40.912117 | 1 | < 0.1% |
| 40.9120636 | 1 | < 0.1% |
| 40.91166687 | 1 | < 0.1% |
| 40.91158676 | 3 | |
| 40.91139603 | 3 | |
| 40.91132355 | 1 | < 0.1% |
| 40.91103745 | 2 | |
| 40.91093445 | 2 | |
| 40.91091919 | 1 | < 0.1% |
longitude
Real number (ℝ)
High correlation Missing
| Distinct | 35627 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 6143 |
| Missing (%) | 3.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.92448 |
| Minimum | -74.253922 |
|---|---|
| Maximum | -73.700722 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 174320 |
| Negative (%) | 96.6% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | -74.253922 |
|---|---|
| 5-th percentile | -74.02636 |
| Q1 | -73.96978 |
| median | -73.929028 |
| Q3 | -73.877975 |
| 95-th percentile | -73.788398 |
| Maximum | -73.700722 |
| Range | 0.55319977 |
| Interquartile range (IQR) | 0.091804504 |
Descriptive statistics
| Standard deviation | 0.07897988 |
|---|---|
| Coefficient of variation (CV) | -0.001068386 |
| Kurtosis | 1.539024 |
| Mean | -73.92448 |
| Median Absolute Deviation (MAD) | 0.045524597 |
| Skewness | -0.34315675 |
| Sum | -12886515 |
| Variance | 0.0062378212 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.80970001 | 509 | 0.3% |
| -73.87685394 | 430 | 0.2% |
| -73.90311432 | 260 | 0.1% |
| -73.93043518 | 177 | 0.1% |
| -73.81090546 | 176 | 0.1% |
| -73.89296722 | 174 | 0.1% |
| -73.7882843 | 154 | 0.1% |
| -73.89842224 | 152 | 0.1% |
| -73.97097778 | 133 | 0.1% |
| -73.94981384 | 131 | 0.1% |
| Other values (35617) | 172024 | |
| (Missing) | 6143 | 3.4% |
| Value | Count | Frequency (%) |
| -74.25392151 | 2 | |
| -74.25376129 | 1 | < 0.1% |
| -74.25319672 | 1 | < 0.1% |
| -74.25318146 | 3 | |
| -74.25315094 | 1 | < 0.1% |
| -74.25313568 | 1 | < 0.1% |
| -74.25255585 | 1 | < 0.1% |
| -74.25144196 | 1 | < 0.1% |
| -74.25099182 | 2 | |
| -74.25046539 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.70072174 | 1 | |
| -73.70075989 | 1 | |
| -73.70077515 | 1 | |
| -73.70095825 | 1 | |
| -73.70096588 | 1 | |
| -73.7009964 | 1 | |
| -73.70117188 | 1 | |
| -73.70121002 | 1 | |
| -73.70127869 | 2 | |
| -73.70161438 | 1 |
geo_status
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Invalid | |
|---|---|
| Missing | 6143 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Invalid |
|---|---|
| 2nd row | Invalid |
| 3rd row | Invalid |
| 4th row | Invalid |
| 5th row | Invalid |
Common Values
| Value | Count | Frequency (%) |
| Invalid | 174320 | |
| Missing | 6143 | 3.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| invalid | 174320 | |
| missing | 6143 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 186606 | |
| n | 180463 | |
| I | 174320 | |
| v | 174320 | |
| a | 174320 | |
| l | 174320 | |
| d | 174320 | |
| s | 12286 | 1.0% |
| M | 6143 | 0.5% |
| g | 6143 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1263241 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 186606 | |
| n | 180463 | |
| I | 174320 | |
| v | 174320 | |
| a | 174320 | |
| l | 174320 | |
| d | 174320 | |
| s | 12286 | 1.0% |
| M | 6143 | 0.5% |
| g | 6143 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1263241 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 186606 | |
| n | 180463 | |
| I | 174320 | |
| v | 174320 | |
| a | 174320 | |
| l | 174320 | |
| d | 174320 | |
| s | 12286 | 1.0% |
| M | 6143 | 0.5% |
| g | 6143 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1263241 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 186606 | |
| n | 180463 | |
| I | 174320 | |
| v | 174320 | |
| a | 174320 | |
| l | 174320 | |
| d | 174320 | |
| s | 12286 | 1.0% |
| M | 6143 | 0.5% |
| g | 6143 | 0.5% |
location
Text
Missing
| Distinct | 87425 |
|---|---|
| Distinct (%) | 50.2% |
| Missing | 6143 |
| Missing (%) | 3.4% |
| Memory size | 2.8 MiB |
Length
| Max length | 141 |
|---|---|
| Median length | 140 |
| Mean length | 140.05835 |
| Min length | 64 |
Unique
| Unique | 59282 ? |
|---|---|
| Unique (%) | 34.0% |
Sample
| 1st row | {'longitude': '-74.07264521772677', 'latitude': '40.64414468130328', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
|---|---|
| 2nd row | {'longitude': '-73.86716098015863', 'latitude': '40.6867859735264', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 3rd row | {'longitude': '-74.00286802659268', 'latitude': '40.72085652445241', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 4th row | {'longitude': '-73.8429876417836', 'latitude': '40.70994335729081', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 5th row | {'longitude': '-73.89639140549146', 'latitude': '40.696914016789876', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| Value | Count | Frequency (%) |
| 697268 | ||
| longitude | 174320 | 7.7% |
| latitude | 174320 | 7.7% |
| state | 174317 | 7.7% |
| city | 174317 | 7.7% |
| human_address | 174317 | 7.7% |
| zip | 174317 | 7.7% |
| address | 174317 | 7.7% |
| 40.72195913199264 | 509 | < 0.1% |
| 73.80969682426189 | 509 | < 0.1% |
| Other values (174845) | 347622 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 2789072 | 11.4% |
| ' | 2091828 | 8.6% |
| 2091813 | 8.6% | |
| : | 1220225 | 5.0% |
| t | 1045911 | 4.3% |
| d | 1045908 | 4.3% |
| e | 871591 | 3.6% |
| a | 871588 | 3.6% |
| , | 871588 | 3.6% |
| s | 871585 | 3.6% |
| Other values (28) | 10643862 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24414971 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 2789072 | 11.4% |
| ' | 2091828 | 8.6% |
| 2091813 | 8.6% | |
| : | 1220225 | 5.0% |
| t | 1045911 | 4.3% |
| d | 1045908 | 4.3% |
| e | 871591 | 3.6% |
| a | 871588 | 3.6% |
| , | 871588 | 3.6% |
| s | 871585 | 3.6% |
| Other values (28) | 10643862 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24414971 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 2789072 | 11.4% |
| ' | 2091828 | 8.6% |
| 2091813 | 8.6% | |
| : | 1220225 | 5.0% |
| t | 1045911 | 4.3% |
| d | 1045908 | 4.3% |
| e | 871591 | 3.6% |
| a | 871588 | 3.6% |
| , | 871588 | 3.6% |
| s | 871585 | 3.6% |
| Other values (28) | 10643862 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24414971 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 2789072 | 11.4% |
| ' | 2091828 | 8.6% |
| 2091813 | 8.6% | |
| : | 1220225 | 5.0% |
| t | 1045911 | 4.3% |
| d | 1045908 | 4.3% |
| e | 871591 | 3.6% |
| a | 871588 | 3.6% |
| , | 871588 | 3.6% |
| s | 871585 | 3.6% |
| Other values (28) | 10643862 |
zip_codes
Real number (ℝ)
High correlation Missing
| Distinct | 214 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 8411 |
| Missing (%) | 4.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14593.273 |
| Minimum | 10090 |
|---|---|
| Maximum | 24894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.1 MiB |
Quantile statistics
| Minimum | 10090 |
|---|---|
| 5-th percentile | 10700 |
| Q1 | 11723 |
| median | 13513 |
| Q3 | 17212 |
| 95-th percentile | 24015 |
| Maximum | 24894 |
| Range | 14804 |
| Interquartile range (IQR) | 5489 |
Descriptive statistics
| Standard deviation | 3641.4319 |
|---|---|
| Coefficient of variation (CV) | 0.24952811 |
| Kurtosis | 1.0668703 |
| Mean | 14593.273 |
| Median Absolute Deviation (MAD) | 1908 |
| Skewness | 1.2433916 |
| Sum | 2.5108019 × 109 |
| Variance | 13260027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13510 | 3166 | 1.8% |
| 15310 | 2774 | 1.5% |
| 11605 | 2704 | 1.5% |
| 10935 | 2173 | 1.2% |
| 17613 | 2125 | 1.2% |
| 10931 | 2018 | 1.1% |
| 11606 | 2010 | 1.1% |
| 10930 | 1987 | 1.1% |
| 12428 | 1956 | 1.1% |
| 10936 | 1951 | 1.1% |
| Other values (204) | 149188 | |
| (Missing) | 8411 | 4.7% |
| Value | Count | Frequency (%) |
| 10090 | 451 | |
| 10091 | 41 | < 0.1% |
| 10092 | 341 | |
| 10093 | 10 | < 0.1% |
| 10094 | 5 | < 0.1% |
| 10095 | 6 | < 0.1% |
| 10096 | 3 | < 0.1% |
| 10097 | 1 | < 0.1% |
| 10098 | 26 | < 0.1% |
| 10099 | 717 |
| Value | Count | Frequency (%) |
| 24894 | 3 | < 0.1% |
| 24672 | 7 | < 0.1% |
| 24671 | 407 | 0.2% |
| 24670 | 1013 | |
| 24669 | 969 | |
| 24668 | 768 | |
| 24340 | 1119 | |
| 24339 | 183 | 0.1% |
| 24338 | 396 | 0.2% |
| 24337 | 338 | 0.2% |
Request_Closing_Time
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Request_Closing_Time_in_Hours
Real number (ℝ)
High correlation
| Distinct | 98161 |
|---|---|
| Distinct (%) | 54.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.928009 |
| Minimum | -1127 |
|---|---|
| Maximum | 1619.4422 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1162 |
| Negative (%) | 0.6% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -1127 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2.9629167 |
| median | 9.0244444 |
| Q3 | 47.294583 |
| 95-th percentile | 243.06514 |
| Maximum | 1619.4422 |
| Range | 2746.4422 |
| Interquartile range (IQR) | 44.331667 |
Descriptive statistics
| Standard deviation | 124.37419 |
|---|---|
| Coefficient of variation (CV) | 2.4910704 |
| Kurtosis | 37.293513 |
| Mean | 49.928009 |
| Median Absolute Deviation (MAD) | 7.7572222 |
| Skewness | 4.5141019 |
| Sum | 9010158.3 |
| Variance | 15468.938 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 8058 | 4.5% |
| -71 | 184 | 0.1% |
| 1.000277778 | 159 | 0.1% |
| 1.000555556 | 146 | 0.1% |
| 1.033333333 | 139 | 0.1% |
| -95 | 131 | 0.1% |
| 1.016666667 | 118 | 0.1% |
| 1.5 | 109 | 0.1% |
| 1.066666667 | 80 | < 0.1% |
| 1.05 | 79 | < 0.1% |
| Other values (98151) | 171260 |
| Value | Count | Frequency (%) |
| -1127 | 5 | < 0.1% |
| -1055.016667 | 2 | < 0.1% |
| -1055 | 1 | < 0.1% |
| -1031 | 4 | < 0.1% |
| -1007.016667 | 2 | < 0.1% |
| -1007 | 19 | |
| -983.0166667 | 2 | < 0.1% |
| -983 | 30 | |
| -959 | 2 | < 0.1% |
| -935 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1619.442222 | 1 | |
| 1616.298611 | 1 | |
| 1610.062778 | 1 | |
| 1588.381111 | 1 | |
| 1585.811111 | 1 | |
| 1583.920278 | 1 | |
| 1583.510556 | 1 | |
| 1583.062778 | 1 | |
| 1581.865833 | 1 | |
| 1577.207778 | 1 |
Request_Closing_Time_in_Seconds
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Year-Month
Date
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2019-09-01 00:00:00 |
|---|---|
| Maximum | 2019-12-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Interactions
Correlations
| Request_Closing_Time_in_Hours | agency | borough | city | days_to_close | geo_status | incident_zip | latitude | longitude | status | unique_key | zip_codes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Request_Closing_Time_in_Hours | 1.000 | 0.134 | 0.035 | 0.043 | 1.000 | 0.232 | -0.045 | 0.072 | 0.018 | 0.483 | -0.085 | -0.082 |
| agency | 0.134 | 1.000 | 0.165 | 0.125 | 0.127 | 0.392 | 0.103 | 0.112 | 0.111 | 0.326 | 0.089 | 0.080 |
| borough | 0.035 | 0.165 | 1.000 | 0.921 | 0.024 | 0.318 | 0.690 | 0.572 | 0.614 | 0.024 | 0.027 | 0.609 |
| city | 0.043 | 0.125 | 0.921 | 1.000 | 0.028 | 0.158 | 0.846 | 0.530 | 0.637 | 0.034 | 0.038 | 0.757 |
| days_to_close | 1.000 | 0.127 | 0.024 | 0.028 | 1.000 | 0.010 | -0.044 | 0.072 | 0.021 | 0.076 | -0.083 | -0.083 |
| geo_status | 0.232 | 0.392 | 0.318 | 0.158 | 0.010 | 1.000 | 0.026 | 1.000 | 1.000 | 0.220 | 0.031 | 1.000 |
| incident_zip | -0.045 | 0.103 | 0.690 | 0.846 | -0.044 | 0.026 | 1.000 | -0.439 | 0.548 | 0.031 | -0.002 | 0.717 |
| latitude | 0.072 | 0.112 | 0.572 | 0.530 | 0.072 | 1.000 | -0.439 | 1.000 | 0.355 | 0.018 | 0.006 | -0.516 |
| longitude | 0.018 | 0.111 | 0.614 | 0.637 | 0.021 | 1.000 | 0.548 | 0.355 | 1.000 | 0.024 | 0.005 | 0.217 |
| status | 0.483 | 0.326 | 0.024 | 0.034 | 0.076 | 0.220 | 0.031 | 0.018 | 0.024 | 1.000 | 0.041 | 0.019 |
| unique_key | -0.085 | 0.089 | 0.027 | 0.038 | -0.083 | 0.031 | -0.002 | 0.006 | 0.005 | 0.041 | 1.000 | -0.021 |
| zip_codes | -0.082 | 0.080 | 0.609 | 0.757 | -0.083 | 1.000 | 0.717 | -0.516 | 0.217 | 0.019 | -0.021 | 1.000 |
Missing values
Sample
| unique_key | created_at | closed_at | resolution_date_update | resolution_description | days_to_close | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | city | facility_type | status | borough | latitude | longitude | geo_status | location | zip_codes | Request_Closing_Time | Request_Closing_Time_in_Hours | Request_Closing_Time_in_Seconds | Year-Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 43859987.0 | 2019-09-22 13:39:34 | 2019-09-24 08:36:11 | 2019-09-24 12:36:12 | After performing a thorough search, the Department of Transportation was unable to find the lost ite | 1.789317 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | Bridge | 10301.0 | SAINT GEORGE FERRY | STATEN ISLAND | NaN | Closed | STATEN ISLAND | 40.644146 | -74.072647 | Invalid | {'longitude': '-74.07264521772677', 'latitude': '40.64414468130328', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 10369.0 | 1 days 18:56:37 | 43.943611 | 1 days 18:56:37 | 2019-09 |
| 5 | 43859988.0 | 2019-09-22 15:27:37 | 2019-09-22 16:31:30 | 2019-09-22 20:31:32 | The Police Department responded and upon arrival those responsible for the condition were gone. | 0.044363 | NYPD | New York City Police Department | Drinking | In Public | Street/Sidewalk | 11208.0 | 600 RIDGEWOOD AVENUE | BROOKLYN | NaN | Closed | BROOKLYN | 40.686787 | -73.867165 | Invalid | {'longitude': '-73.86716098015863', 'latitude': '40.6867859735264', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 17215.0 | 0 days 01:03:53 | 2.064722 | 0 days 01:03:53 | 2019-09 |
| 6 | 43859989.0 | 2019-09-22 23:16:10 | 2019-10-01 14:01:39 | 2019-09-26 21:52:45 | NaN | 8.614919 | DOHMH | Department of Health and Mental Hygiene | Rodent | Rat Sighting | Street Area | 10013.0 | 11 GREENE STREET | NEW YORK | NaN | Closed | MANHATTAN | 40.720856 | -74.002869 | Invalid | {'longitude': '-74.00286802659268', 'latitude': '40.72085652445241', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 12076.0 | 8 days 14:45:29 | 207.758056 | 8 days 14:45:29 | 2019-09 |
| 7 | 43859990.0 | 2019-09-22 21:36:39 | 2019-09-22 21:36:40 | NaT | NaN | 0.000012 | EDC | Economic Development Corporation | Noise - Helicopter | Other | Above Address | 11375.0 | 101-21 75 ROAD | FOREST HILLS | NaN | Closed | QUEENS | 40.709942 | -73.842987 | Invalid | {'longitude': '-73.8429876417836', 'latitude': '40.70994335729081', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 14786.0 | 0 days 00:00:01 | 1.000278 | 0 days 00:00:01 | 2019-09 |
| 8 | 43859991.0 | 2019-09-22 14:43:29 | 2019-09-22 14:44:43 | 2019-09-22 18:44:48 | The agency was unable to respond to this complaint because they allocated resources to other critica | 0.000856 | DPR | Department of Parks and Recreation | Violation of Park Rules | Smoking | Park | 11385.0 | 60-09 SAINT FELIX AVENUE | RIDGEWOOD | NaN | Closed | QUEENS | 40.696915 | -73.896393 | Invalid | {'longitude': '-73.89639140549146', 'latitude': '40.696914016789876', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 15310.0 | 0 days 00:01:14 | 1.020556 | 0 days 00:01:14 | 2019-09 |
| 19 | 43860006.0 | 2019-09-22 12:42:00 | 2019-09-22 12:42:00 | 2019-09-22 12:42:00 | The Department of Sanitation removed the items. | 0.000000 | DSNY | BCC - Queens East | Derelict Vehicles | 14 Derelict Vehicles | Street | 11413.0 | 143-50 229 STREET | SPRINGFIELD GARDENS | DSNY Garage | Closed | QUEENS | 40.664200 | -73.749046 | Invalid | {'longitude': '-73.74904961976131', 'latitude': '40.6641997943848', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 15313.0 | 0 days 00:00:00 | 1.000000 | 0 days 00:00:00 | 2019-09 |
| 20 | 43860007.0 | 2019-09-22 12:07:00 | 2019-09-22 12:07:00 | 2019-09-22 12:07:00 | The Department of Sanitation removed the items. | 0.000000 | DSNY | BCC - Queens West | Derelict Vehicles | 14 Derelict Vehicles | Street | 11416.0 | 97-25 106 STREET | OZONE PARK | DSNY Garage | Closed | QUEENS | 40.688175 | -73.837967 | Invalid | {'longitude': '-73.83796551186634', 'latitude': '40.688175850538464', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 24012.0 | 0 days 00:00:00 | 1.000000 | 0 days 00:00:00 | 2019-09 |
| 34 | 43860023.0 | 2019-09-22 21:25:06 | 2019-09-23 12:06:30 | 2019-09-23 16:06:34 | The Police Department responded to the complaint and determined that police action was not necessary | 0.612083 | NYPD | New York City Police Department | Homeless Encampment | NaN | Street/Sidewalk | 10075.0 | 315 EAST 77 STREET | NEW YORK | NaN | Closed | MANHATTAN | 40.771778 | -73.955421 | Invalid | {'longitude': '-73.95541952970686', 'latitude': '40.771779498956356', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 10092.0 | 0 days 14:41:24 | 15.690000 | 0 days 14:41:24 | 2019-09 |
| 44 | 43860038.0 | 2019-09-22 22:03:01 | 2019-09-23 17:31:13 | 2019-09-23 21:31:17 | The Police Department responded to the complaint and took action to fix the condition. | 0.811250 | NYPD | New York City Police Department | Illegal Parking | Commercial Overnight Parking | Street/Sidewalk | 11230.0 | 1036 OCEAN PARKWAY | BROOKLYN | NaN | Closed | BROOKLYN | 40.623291 | -73.970314 | Invalid | {'longitude': '-73.97031698905789', 'latitude': '40.62328968281543', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 13513.0 | 0 days 19:28:12 | 20.470000 | 0 days 19:28:12 | 2019-09 |
| 45 | 43860039.0 | 2019-09-22 21:12:47 | 2019-09-23 02:42:06 | 2019-09-23 06:42:10 | The Police Department responded to the complaint and with the information available observed no evid | 0.228692 | NYPD | New York City Police Department | Illegal Parking | Commercial Overnight Parking | Street/Sidewalk | 11236.0 | 1138 EAST 108 STREET | BROOKLYN | NaN | Closed | BROOKLYN | 40.644905 | -73.888107 | Invalid | {'longitude': '-73.88810849849925', 'latitude': '40.64490369132947', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 13827.0 | 0 days 05:29:19 | 6.488611 | 0 days 05:29:19 | 2019-09 |
| unique_key | created_at | closed_at | resolution_date_update | resolution_description | days_to_close | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | city | facility_type | status | borough | latitude | longitude | geo_status | location | zip_codes | Request_Closing_Time | Request_Closing_Time_in_Hours | Request_Closing_Time_in_Seconds | Year-Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 209956 | 45054955.0 | 2019-11-30 13:19:55 | 2019-11-30 18:08:50 | 2019-11-30 18:08:50 | The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | 0.200637 | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11226.0 | 1060 ROGERS AVENUE | BROOKLYN | NaN | Closed | BROOKLYN | 40.644047 | -73.951767 | Invalid | {'longitude': '-73.95176811885132', 'latitude': '40.64404497558585', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 04:48:55 | 5.815278 | 0 days 04:48:55 | 2019-11 |
| 209957 | 45054956.0 | 2019-11-30 15:33:25 | 2019-11-30 15:44:26 | 2019-11-30 20:44:28 | The Department of Parks and Recreation has completed the requested work order and corrected the prob | 0.007650 | DPR | Department of Parks and Recreation | Violation of Park Rules | Obstructing Public Use | Park | 10472.0 | ROSEDALE AVENUE | NaN | NaN | Closed | BRONX | 40.827427 | -73.868225 | Invalid | {'longitude': '-73.86822438047447', 'latitude': '40.82742530197013', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 00:11:01 | 1.183611 | 0 days 00:11:01 | 2019-11 |
| 209959 | 45054958.0 | 2019-11-30 14:22:42 | 2019-11-30 19:13:11 | 2019-12-01 00:13:17 | The Police Department responded to the complaint and determined that police action was not necessary | 0.201725 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Street/Sidewalk | 10075.0 | 1 CHEROKEE PLACE | NEW YORK | NaN | Closed | MANHATTAN | 40.769566 | -73.949875 | Invalid | {'longitude': '-73.9498757147109', 'latitude': '40.76956496035729', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 04:50:29 | 5.841389 | 0 days 04:50:29 | 2019-11 |
| 209980 | 45054980.0 | 2019-11-30 21:46:44 | 2019-11-30 23:26:37 | 2019-12-01 04:26:40 | The Police Department responded to the complaint and with the information available observed no evid | 0.069363 | NYPD | New York City Police Department | Noise - Residential | Loud Music/Party | Residential Building/House | 11238.0 | 520 CLINTON AVENUE | BROOKLYN | NaN | Closed | BROOKLYN | 40.682648 | -73.966736 | Invalid | {'longitude': '-73.96673913670575', 'latitude': '40.68264735984039', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 01:39:53 | 2.664722 | 0 days 01:39:53 | 2019-11 |
| 209981 | 45054981.0 | 2019-11-30 21:55:41 | 2019-11-30 22:35:42 | 2019-12-01 03:35:45 | The Police Department responded to the complaint and with the information available observed no evid | 0.027789 | NYPD | New York City Police Department | Noise - Residential | Banging/Pounding | Residential Building/House | 10039.0 | 220 WEST 149 STREET | NEW YORK | NaN | Closed | MANHATTAN | 40.824554 | -73.938126 | Invalid | {'longitude': '-73.93812389996073', 'latitude': '40.824555379608164', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 00:40:01 | 1.666944 | 0 days 00:40:01 | 2019-11 |
| 209990 | 45054991.0 | 2019-11-28 15:42:15 | 2019-11-29 21:10:00 | 2019-11-29 21:10:00 | The Department of Transportation inspected this complaint and repaired the problem. | 1.227604 | DOT | Department of Transportation | Street Condition | Pothole | NaN | 11201.0 | NaN | BROOKLYN | NaN | Closed | BROOKLYN | 40.695953 | -73.982391 | Invalid | {'longitude': '-73.98239076393166', 'latitude': '40.69595197545211', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 1 days 05:27:45 | 30.462500 | 1 days 05:27:45 | 2019-11 |
| 209991 | 45054992.0 | 2019-11-28 15:44:43 | 2019-11-29 22:15:00 | 2019-11-29 22:15:00 | The Department of Transportation inspected this complaint and repaired the problem. | 1.271030 | DOT | Department of Transportation | Street Condition | Pothole | NaN | 11206.0 | SEIGEL STREET | BROOKLYN | NaN | Closed | BROOKLYN | NaN | NaN | Missing | NaN | NaN | 1 days 06:30:17 | 31.504722 | 1 days 06:30:17 | 2019-11 |
| 209992 | 45054993.0 | 2019-11-28 15:45:44 | 2019-11-29 22:30:00 | 2019-11-29 22:30:00 | The Department of Transportation inspected this complaint and repaired the problem. | 1.280741 | DOT | Department of Transportation | Street Condition | Pothole | NaN | 11206.0 | NaN | BROOKLYN | NaN | Closed | BROOKLYN | 40.701797 | -73.940544 | Invalid | {'longitude': '-73.94054603053874', 'latitude': '40.70179804436484', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 1 days 06:44:16 | 31.737778 | 1 days 06:44:16 | 2019-11 |
| 209993 | 45054994.0 | 2019-11-28 15:38:20 | 2019-11-29 15:55:00 | 2019-11-29 15:55:00 | The Department of Transportation inspected this complaint and repaired the problem. | 1.011574 | DOT | Department of Transportation | Street Condition | Pothole | NaN | 11102.0 | ASTORIA BOULEVARD | ASTORIA | NaN | Closed | QUEENS | 40.772133 | -73.929565 | Invalid | {'longitude': '-73.92956190226768', 'latitude': '40.772131643406595', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 1 days 00:16:40 | 25.277778 | 1 days 00:16:40 | 2019-11 |
| 209994 | 45054995.0 | 2019-11-30 22:59:49 | 2019-12-01 00:53:03 | 2019-12-01 05:53:05 | The Police Department responded to the complaint and determined that police action was not necessary | 0.078634 | NYPD | New York City Police Department | Panhandling | NaN | Store/Commercial | 10038.0 | 160 BROADWAY | NEW YORK | NaN | Closed | MANHATTAN | 40.709492 | -74.010239 | Invalid | {'longitude': '-74.01024017537995', 'latitude': '40.70949279464519', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | 0 days 01:53:14 | 2.887222 | 0 days 01:53:14 | 2019-11 |